USE [wdms]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_GetAuthoredDocuments (
	@par_userid int)
AS
BEGIN
    -- Insert statements for procedure here
	SELECT [Document].[doc_title], [Document].[doc_id]
	FROM [Document]
	WHERE @par_userid=[Document].user1_id
END